﻿CREATE TABLE [dbo].[AttendanceInfoSet] (
    [Id]                   UNIQUEIDENTIFIER NOT NULL,
    [UserId]               UNIQUEIDENTIFIER NOT NULL,
    [Date]                 DATETIME         NOT NULL,
    [AttendanceTypeValue]  INT              NOT NULL,
    [ActionTime]           DATETIME         NOT NULL,
    [Explanation]          NVARCHAR (MAX)   NULL,
    [IsAbnormalAttendance] BIT              NOT NULL
);

